package com.dengyafei.mapper;

import com.dengyafei.bean.PositionEntity;
import com.dengyafei.bean.PositionEntityExample;

import java.awt.*;
import java.util.List;

import com.dengyafei.domin.dto.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @author 邓亚非
 */
@Mapper
public interface PositionEntityMapper {
    int countByExample(PositionEntityExample example);

    int deleteByExample(PositionEntityExample example);

    int deleteByPrimaryKey(Integer pid);

    int insert(PositionEntity record);

    int insertSelective(PositionEntity record);

    List<PositionEntity> selectByExample(PositionEntityExample example);

    PositionEntity selectByPrimaryKey(Integer pid);

    int updateByExampleSelective(@Param("record") PositionEntity record, @Param("example") PositionEntityExample example);

    int updateByExample(@Param("record") PositionEntity record, @Param("example") PositionEntityExample example);

    int updateByPrimaryKeySelective(PositionEntity record);

    int updateByPrimaryKey(PositionEntity record);

    List<PositionEntity> queryByHid(Integer Hid);

    List<PositionEntity> queryByNameAndHid(PositionQueryByNameDTO positionQueryByNameDTO);

    List<PositionEntity> queryByName(PositionSearchByNameDTO positionSearchByNameDTO);

    List<PositionEntity> findAllByIds(List<Integer> ids);

    List<PositionEntity> recommendPositions();

    List<PositionEntity> queryByHidList(List<Integer> hids);

    List<String>  queryScorePosition(List<Integer> list);

    List<PositionAverageSalaryCityDTO> queryPositionAverageSalaryCity();

    List<PositionMaxSalaryDTO> queryPositionMaxSalary();

    List<PositionEntity> queryPositiones();
}